Login     Signup
   info@zetlantechnologies.com        +91-8680961847

Home   >   MySQL Server


MySQL is an open-source relational database management system (RDBMS) that uses SQL (Structured Query Language) to manage and store data. It is developed, distributed, and supported by Oracle. MySQL stores data in tables, which are organized into schemas, and uses these schemas to define how data is organized and stored, as well as relationships between different tables


Key Features and Components:


Course Details

1. Introduction to MySQL

  • What is MySQL?
  • Installing MySQL (Windows, macOS, Linux)
  • MySQL Workbench & Command-Line Interface
  • Basic MySQL Commands

  • Understanding Databases & Tables
  • Data Types in MySQL
  • Creating, Altering, and Dropping Databases
  • Creating, Altering, and Dropping Tables

  • Inserting Data (INSERT)
  • Updating Data (UPDATE)
  • Deleting Data (DELETE)
  • Selecting Data (SELECT)

  • Using WHERE Clause
  • Logical Operators (AND, OR, NOT)
  • Sorting Results (ORDER BY)
  • Limiting Results (LIMIT)

  • Using COUNT(), SUM(), AVG(), MIN(), MAX()
  • Grouping Data with GROUP BY
  • Filtering Groups with HAVING

  • Understanding Joins
  • Inner Join (INNER JOIN)
  • Left Join (LEFT JOIN)
  • Right Join (RIGHT JOIN)
  • Full Join (FULL JOIN)
  • Self Join
  • Cross Join

  • What is a Subquery?
  • Using Subqueries in SELECT, FROM, WHERE
  • Correlated Subqueries
  • Common Table Expressions (CTEs)

  • Primary Key (PRIMARY KEY)
  • Foreign Key (FOREIGN KEY)
  • Unique Constraint (UNIQUE)
  • Not Null Constraint (NOT NULL)
  • Default Values (DEFAULT)
  • Check Constraint (CHECK)

  • Introduction to Stored Procedures
  • Creating & Executing Stored Procedures
  • Creating & Using Functions
  • Parameters in Stored Procedures

  • Understanding Triggers
  • Creating & Managing Triggers
  • MySQL Events & Scheduled Tasks
  • What is a Transaction?
  • Using COMMIT & ROLLBACK
  • Savepoints (SAVEPOINT)
  • Isolation Levels (READ COMMITTED, SERIALIZABLE, etc.)
  • Handling Deadlocks


Fees Structure : 12500 INR / 145 USD
Total No of Class : 58 Video Class
Class Duration : 45:00 Working Hours
Download Feature : Download Avalable
Technical Support : Call / Whatsapp : +91 8680961847
Working Hours : Monday to Firday 9 AM to 6 PM
Payment Mode : Credit Card / Debit Card / NetBanking / Wallet (Gpay/Phonepay/Paytm/WhatsApp Pay)

Brochure       Buy Now       Sample Demo

Fees Structure : 22000 INR / 256 USD
Class Duration : 45 Days
Class Recording : Live Class Recording available
Class Time : Monday to Firday 1.5 hours per day / Weekend 3 Hours per day
Technical Support : Call / Whatsapp : +91 8680961847
Working Hours : Monday to Firday 9 AM to 6 PM
Payment Mode : Credit Card / Debit Card / NetBanking / Wallet (Gpay/Phonepay/Paytm/WhatsApp Pay)

Download Brochure       Pay Online